import tkinter
import chinese_calendar
import pandas as pd
import datetime

per_month_salary_lst_1 = [580, 580, 580, 580, 580, 580, 580, 580, 580, 900, 880]
per_month_salary_lst_2 = [600, 600, 600, 600, 600, 600, 600, 600, 600, 800, 800]

print(len(per_month_salary_lst_1), len(per_month_salary_lst_2))

start_time = datetime.date(2025, 1, 1)  # 指定开始时间
end_time = datetime.date(2025, 12, 31)  # 指定结束时间

workdays = pd.DataFrame(chinese_calendar.get_workdays(start_time, end_time))
workdays = workdays.rename(columns={0: '日期'})
workdays['属性'] = '工作日'
print(workdays)
df = pd.DataFrame(workdays)
df.to_excel('output2025.xlsx', index=False)

hd = pd.DataFrame(chinese_calendar.get_holidays(start_time, end_time))
hd = hd.rename(columns={0: '日期'})
hd['属性'] = '假期'
print(hd)
df = pd.DataFrame(hd)
df.to_excel('output2025.xlsx', index=False)
